791bca26126664531d060b47d7910ff1977ee66e,jooq/jooq-mysql/src/test/java/com/vladmihalcea/book/hpjp/jooq/mysql/crud/UpsertTest.java,UpsertTest,upsert,#DSLContext#,27

Before Change



   private void upsert(DSLContext sql) {
       sql
           .insertInto(POST)
           .columns(POST.ID, POST.TITLE)
           .values(1L, "High-Performance Java Persistence")
           .onDuplicateKeyUpdate()
           .set(POST.TITLE, "High-Performance Java Persistence Book")

After Change



    private void upsert(DSLContext sql, Long id, String owner, Timestamp timestamp) {
        sql
        .insertInto(POST_DETAILS)
        .columns(POST_DETAILS.ID, POST_DETAILS.CREATED_BY, POST_DETAILS.CREATED_ON)
        .values(id, owner, timestamp)
        .onDuplicateKeyUpdate()
        .set(POST_DETAILS.UPDATED_BY, owner)
        .set(POST_DETAILS.UPDATED_ON, timestamp)